Pandas Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	19
Number of observations	21613
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	183
Duplicate rows (%)	0.8%
Total size in memory	3.1 MiB
Average record size in memory	152.0 B

Variable types

Numeric	15
Categorical	4

Alerts

Dataset has 183 (0.8%) duplicate rows	Duplicates
`bathrooms` is highly overall correlated with `bedrooms` and 6 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`floors` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`grade` is highly overall correlated with `bathrooms` and 6 other fields	High correlation
`long` is highly overall correlated with `zipcode`	High correlation
`price_gt_1M` is highly overall correlated with `grade` and 1 other fields	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living15` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`yr_built` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`zipcode` is highly overall correlated with `long`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.2%)	Imbalance
`price_gt_1M` is highly imbalanced (63.8%)	Imbalance
`sqft_basement` has 13126 (60.7%) zeros	Zeros
`yr_renovated` has 20699 (95.8%) zeros	Zeros

Reproduction

Analysis started	2025-06-01 01:00:05.532742
Analysis finished	2025-06-01 01:02:16.670918
Duration	2 minutes and 11.14 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

bedrooms
Real number (ℝ)

High correlation

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3708416

Minimum	0
Maximum	33
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.93006183
Coefficient of variation (CV)	0.27591383
Kurtosis	49.063653
Mean	3.3708416
Median Absolute Deviation (MAD)	1
Skewness	1.9742995
Sum	72854
Variance	0.86501501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	9824	45.5%
4	6882	31.8%
2	2760	12.8%
5	1601	7.4%
6	272	1.3%
1	199	0.9%
7	38	0.2%
0	13	0.1%
8	13	0.1%
9	6	< 0.1%
Other values (3)	5	< 0.1%

Value	Count	Frequency (%)
0	13	0.1%
1	199	0.9%
2	2760	12.8%
3	9824	45.5%
4	6882	31.8%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6882	31.8%
3	9824	45.5%

bathrooms
Real number (ℝ)

High correlation

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1147573

Minimum	0
Maximum	8
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.77016316
Coefficient of variation (CV)	0.36418512
Kurtosis	1.2799024
Mean	2.1147573
Median Absolute Deviation (MAD)	0.5
Skewness	0.51110757
Sum	45706.25
Variance	0.59315129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2.5	5380	24.9%
1	3852	17.8%
1.75	3048	14.1%
2.25	2047	9.5%
2	1930	8.9%
1.5	1446	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (20)	652	3.0%

Value	Count	Frequency (%)
0	10	< 0.1%
0.5	4	< 0.1%
0.75	72	0.3%
1	3852	17.8%
1.25	9	< 0.1%
1.5	1446	6.7%
1.75	3048	14.1%
2	1930	8.9%
2.25	2047	9.5%
2.5	5380	24.9%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

High correlation

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2079.8997

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1427
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13250
Interquartile range (IQR)	1123

Descriptive statistics

Standard deviation	918.4409
Coefficient of variation (CV)	0.44157941
Kurtosis	5.243093
Mean	2079.8997
Median Absolute Deviation (MAD)	540
Skewness	1.4715554
Sum	44952873
Variance	843533.68
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1800	129	0.6%
1660	129	0.6%
1010	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1028)	20318	94.0%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

High correlation

Distinct	9782
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15106.968

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	520
5-th percentile	1800
Q1	5040
median	7618
Q3	10688
95-th percentile	43339.2
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5648

Descriptive statistics

Standard deviation	41420.512
Coefficient of variation (CV)	2.7418151
Kurtosis	285.07782
Mean	15106.968
Median Absolute Deviation (MAD)	2618
Skewness	13.060019
Sum	3.2650689 × 10⁸
Variance	1.7156588 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	120	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9772)	19818	91.7%

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	2	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.494309

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5399889
Coefficient of variation (CV)	0.36136361
Kurtosis	-0.48472294
Mean	1.494309
Median Absolute Deviation (MAD)	0.5
Skewness	0.61617672
Sum	32296.5
Variance	0.29158801
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10680	49.4%
2	8241	38.1%
1.5	1910	8.8%
3	613	2.8%
2.5	161	0.7%
3.5	8	< 0.1%

Value	Count	Frequency (%)
1	10680	49.4%
1.5	1910	8.8%
2	8241	38.1%
2.5	161	0.7%
3	613	2.8%
3.5	8	< 0.1%

Value	Count	Frequency (%)
3.5	8	< 0.1%
3	613	2.8%
2.5	161	0.7%
2	8241	38.1%
1.5	1910	8.8%
1	10680	49.4%

waterfront
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	21450
1	163

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21613
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	21450	99.2%
1	163	0.8%

view
Categorical

High correlation Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	19489
2	963
3	510
1	332
4	319

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21613
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	19489	90.2%
2	963	4.5%
3	510	2.4%
1	332	1.5%
4	319	1.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

3	14031
4	5679
5	1701
2	172
1	30

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21613
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
3	14031	64.9%
4	5679	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

grade
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6568732

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1754588
Coefficient of variation (CV)	0.15351681
Kurtosis	1.1909321
Mean	7.6568732
Median Absolute Deviation (MAD)	1
Skewness	0.7711032
Sum	165488
Variance	1.3817033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8981	41.6%
8	6068	28.1%
9	2615	12.1%
6	2038	9.4%
10	1134	5.2%
11	399	1.8%
5	242	1.1%
12	90	0.4%
4	29	0.1%
13	13	0.1%
Other values (2)	4	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	242	1.1%
6	2038	9.4%
7	8981	41.6%
8	6068	28.1%
9	2615	12.1%
10	1134	5.2%
11	399	1.8%

Value	Count	Frequency (%)
13	13	0.1%
12	90	0.4%
11	399	1.8%
10	1134	5.2%
9	2615	12.1%
8	6068	28.1%
7	8981	41.6%
6	2038	9.4%
5	242	1.1%
4	29	0.1%

sqft_above
Real number (ℝ)

High correlation

Distinct	946
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1788.3907

Minimum	290
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	290
5-th percentile	850
Q1	1190
median	1560
Q3	2210
95-th percentile	3400
Maximum	9410
Range	9120
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	828.09098
Coefficient of variation (CV)	0.46303695
Kurtosis	3.4023036
Mean	1788.3907
Median Absolute Deviation (MAD)	450
Skewness	1.4466645
Sum	38652488
Variance	685734.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	212	1.0%
1010	210	1.0%
1200	206	1.0%
1220	192	0.9%
1140	184	0.9%
1400	180	0.8%
1060	178	0.8%
1180	177	0.8%
1340	176	0.8%
1250	174	0.8%
Other values (936)	19724	91.3%

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Real number (ℝ)

Zeros

Distinct	306
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291.50905

Minimum	0
Maximum	4820
Zeros	13126
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.57504
Coefficient of variation (CV)	1.5182206
Kurtosis	2.7155742
Mean	291.50905
Median Absolute Deviation (MAD)	0
Skewness	1.5779651
Sum	6300385
Variance	195872.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13126	60.7%
600	221	1.0%
700	218	1.0%
500	214	1.0%
800	206	1.0%
400	184	0.9%
1000	149	0.7%
900	144	0.7%
300	142	0.7%
200	108	0.5%
Other values (296)	6901	31.9%

Value	Count	Frequency (%)
0	13126	60.7%
10	2	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

High correlation

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1971.0051

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.373411
Coefficient of variation (CV)	0.014902757
Kurtosis	-0.6574075
Mean	1971.0051
Median Absolute Deviation (MAD)	23
Skewness	-0.4698054
Sum	42599334
Variance	862.79726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	559	2.6%
2006	454	2.1%
2005	450	2.1%
2004	433	2.0%
2003	422	2.0%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	367	1.7%
Other values (106)	17326	80.2%

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%
1905	74	0.3%
1906	92	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	559	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%
2010	143	0.7%
2009	230	1.1%
2008	367	1.7%
2007	417	1.9%
2006	454	2.1%

yr_renovated
Real number (ℝ)

Zeros

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.402258

Minimum	0
Maximum	2015
Zeros	20699
Zeros (%)	95.8%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	401.67924
Coefficient of variation (CV)	4.7591054
Kurtosis	18.701152
Mean	84.402258
Median Absolute Deviation (MAD)	0
Skewness	4.5494934
Sum	1824186
Variance	161346.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20699	95.8%
2014	91	0.4%
2013	37	0.2%
2003	36	0.2%
2005	35	0.2%
2007	35	0.2%
2000	35	0.2%
2004	26	0.1%
1990	25	0.1%
2006	24	0.1%
Other values (60)	570	2.6%

Value	Count	Frequency (%)
0	20699	95.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	16	0.1%
2014	91	0.4%
2013	37	0.2%
2012	11	0.1%
2011	13	0.1%
2010	18	0.1%
2009	22	0.1%
2008	18	0.1%
2007	35	0.2%
2006	24	0.1%

zipcode
Real number (ℝ)

High correlation

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98077.94

Minimum	98001
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	98001
5-th percentile	98004
Q1	98033
median	98065
Q3	98118
95-th percentile	98177
Maximum	98199
Range	198
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	53.505026
Coefficient of variation (CV)	0.00054553579
Kurtosis	-0.85347887
Mean	98077.94
Median Absolute Deviation (MAD)	42
Skewness	0.40566121
Sum	2.1197585 × 10⁹
Variance	2862.7878
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98103	602	2.8%
98038	590	2.7%
98115	583	2.7%
98052	574	2.7%
98117	553	2.6%
98042	548	2.5%
98034	545	2.5%
98118	508	2.4%
98023	499	2.3%
98006	498	2.3%
Other values (60)	16113	74.6%

Value	Count	Frequency (%)
98001	362	1.7%
98002	199	0.9%
98003	280	1.3%
98004	317	1.5%
98005	168	0.8%
98006	498	2.3%
98007	141	0.7%
98008	283	1.3%
98010	100	0.5%
98011	195	0.9%

Value	Count	Frequency (%)
98199	317	1.5%
98198	280	1.3%
98188	136	0.6%
98178	262	1.2%
98177	255	1.2%
98168	269	1.2%
98166	254	1.2%
98155	446	2.1%
98148	57	0.3%
98146	288	1.3%

lat
Real number (ℝ)

Distinct	5034
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.560053

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.471
median	47.5718
Q3	47.678
95-th percentile	47.74964
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.207

Descriptive statistics

Standard deviation	0.13856371
Coefficient of variation (CV)	0.0029134474
Kurtosis	-0.676313
Mean	47.560053
Median Absolute Deviation (MAD)	0.1049
Skewness	-0.48527048
Sum	1027915.4
Variance	0.019199902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.6624	17	0.1%
47.5322	17	0.1%
47.6846	17	0.1%
47.5491	17	0.1%
47.6955	16	0.1%
47.6886	16	0.1%
47.6711	16	0.1%
47.5402	15	0.1%
47.6842	15	0.1%
47.6904	15	0.1%
Other values (5024)	21452	99.3%

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

High correlation

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.2139

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21613
Negative (%)	100.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.23
Q3	-122.125
95-th percentile	-121.979
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14082834
Coefficient of variation (CV)	-0.0011523104
Kurtosis	1.0495009
Mean	-122.2139
Median Absolute Deviation (MAD)	0.101
Skewness	0.88505298
Sum	-2641408.9
Variance	0.019832622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	116	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	99	0.5%
-122.288	98	0.5%
-122.357	96	0.4%
-122.284	95	0.4%
-122.365	94	0.4%
Other values (742)	20601	95.3%

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

High correlation

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1986.5525

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2360
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	685.3913
Coefficient of variation (CV)	0.34501545
Kurtosis	1.5970958
Mean	1986.5525
Median Absolute Deviation (MAD)	410
Skewness	1.1081813
Sum	42935359
Variance	469761.24
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	197	0.9%
1440	195	0.9%
1560	192	0.9%
1500	181	0.8%
1460	169	0.8%
1580	167	0.8%
1610	166	0.8%
1720	166	0.8%
1800	166	0.8%
1620	165	0.8%
Other values (767)	19849	91.8%

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

High correlation

Distinct	8689
Distinct (%)	40.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12768.456

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	169.0 KiB

Quantile statistics

Minimum	651
5-th percentile	1999.2
Q1	5100
median	7620
Q3	10083
95-th percentile	37062.8
Maximum	871200
Range	870549
Interquartile range (IQR)	4983

Descriptive statistics

Standard deviation	27304.18
Coefficient of variation (CV)	2.1384089
Kurtosis	150.76311
Mean	12768.456
Median Absolute Deviation (MAD)	2505
Skewness	9.5067432
Sum	2.7596463 × 10⁸
Variance	7.4551823 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	427	2.0%
4000	357	1.7%
6000	289	1.3%
7200	211	1.0%
4800	145	0.7%
7500	142	0.7%
8400	116	0.5%
3600	111	0.5%
4500	111	0.5%
5100	109	0.5%
Other values (8679)	19595	90.7%

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

price_gt_1M
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	20121
1	1492

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21613
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

Most occurring characters

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21613	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	20121	93.1%
1	1492	6.9%

	bathrooms	bedrooms	condition	floors	grade	lat	long	price_gt_1M	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated	zipcode
bathrooms	1.000	0.521	0.130	0.547	0.658	0.008	0.262	0.447	0.691	0.192	0.746	0.570	0.069	0.063	0.114	0.102	0.567	0.043	-0.205
bedrooms	0.521	1.000	0.024	0.228	0.381	-0.021	0.191	0.198	0.540	0.230	0.647	0.444	0.217	0.202	0.038	0.000	0.180	0.017	-0.167
condition	0.130	0.024	1.000	0.179	0.154	0.058	0.081	0.052	0.107	0.094	0.060	0.062	0.039	0.013	0.025	0.017	0.248	0.067	0.074
floors	0.547	0.228	0.179	1.000	0.502	0.025	0.149	0.186	0.599	-0.272	0.401	0.305	-0.234	-0.231	0.024	0.022	0.552	0.013	-0.061
grade	0.658	0.381	0.154	0.502	1.000	0.104	0.223	0.587	0.712	0.093	0.716	0.663	0.152	0.156	0.143	0.118	0.501	0.016	-0.182
lat	0.008	-0.021	0.058	0.025	0.104	1.000	-0.143	0.268	-0.026	0.116	0.031	0.028	-0.122	-0.117	0.068	0.034	-0.126	0.025	0.250
long	0.262	0.191	0.081	0.149	0.223	-0.143	1.000	0.118	0.385	-0.200	0.285	0.380	0.371	0.373	0.085	0.096	0.413	-0.075	-0.577
price_gt_1M	0.447	0.198	0.052	0.186	0.587	0.268	0.118	1.000	0.465	0.286	0.549	0.471	0.030	0.010	0.359	0.197	0.085	0.107	0.131
sqft_above	0.691	0.540	0.107	0.599	0.712	-0.026	0.385	0.465	1.000	-0.166	0.844	0.697	0.272	0.254	0.089	0.083	0.472	0.031	-0.279
sqft_basement	0.192	0.230	0.094	-0.272	0.093	0.116	-0.200	0.286	-0.166	1.000	0.328	0.130	0.037	0.031	0.159	0.134	-0.178	0.063	0.115
sqft_living	0.746	0.647	0.060	0.401	0.716	0.031	0.285	0.549	0.844	0.328	1.000	0.747	0.304	0.284	0.149	0.140	0.352	0.053	-0.207
sqft_living15	0.570	0.444	0.062	0.305	0.663	0.028	0.380	0.471	0.697	0.130	0.747	1.000	0.360	0.366	0.147	0.089	0.336	-0.006	-0.287
sqft_lot	0.069	0.217	0.039	-0.234	0.152	-0.122	0.371	0.030	0.272	0.037	0.304	0.360	1.000	0.922	0.040	0.014	-0.038	0.009	-0.319
sqft_lot15	0.063	0.202	0.013	-0.231	0.156	-0.117	0.373	0.010	0.254	0.031	0.284	0.366	0.922	1.000	0.035	0.000	-0.016	0.009	-0.326
view	0.114	0.038	0.025	0.024	0.143	0.068	0.085	0.359	0.089	0.159	0.149	0.147	0.040	0.035	1.000	0.592	0.041	0.109	0.074
waterfront	0.102	0.000	0.017	0.022	0.118	0.034	0.096	0.197	0.083	0.134	0.140	0.089	0.014	0.000	0.592	1.000	0.032	0.092	0.079
yr_built	0.567	0.180	0.248	0.552	0.501	-0.126	0.413	0.085	0.472	-0.178	0.352	0.336	-0.038	-0.016	0.041	0.032	1.000	-0.215	-0.317
yr_renovated	0.043	0.017	0.067	0.013	0.016	0.025	-0.075	0.107	0.031	0.063	0.053	-0.006	0.009	0.009	0.109	0.092	-0.215	1.000	0.062
zipcode	-0.205	-0.167	0.074	-0.061	-0.182	0.250	-0.577	0.131	-0.279	0.115	-0.207	-0.287	-0.319	-0.326	0.074	0.079	-0.317	0.062	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	zipcode	lat	long	sqft_living15	sqft_lot15	price_gt_1M
0	3	1.00	1180	5650	1.0	3	7	1180	0	1955	0	98178	47.5112	-122.257	1340	5650	0
1	3	2.25	2570	7242	2.0	3	7	2170	400	1951	1991	98125	47.7210	-122.319	1690	7639	0
2	2	1.00	770	10000	1.0	3	6	770	0	1933	0	98028	47.7379	-122.233	2720	8062	0
3	4	3.00	1960	5000	1.0	5	7	1050	910	1965	0	98136	47.5208	-122.393	1360	5000	0
4	3	2.00	1680	8080	1.0	3	8	1680	0	1987	0	98074	47.6168	-122.045	1800	7503	0
5	4	4.50	5420	101930	1.0	3	11	3890	1530	2001	0	98053	47.6561	-122.005	4760	101930	1
6	3	2.25	1715	6819	2.0	3	7	1715	0	1995	0	98003	47.3097	-122.327	2238	6819	0
7	3	1.50	1060	9711	1.0	3	7	1060	0	1963	0	98198	47.4095	-122.315	1650	9711	0
8	3	1.00	1780	7470	1.0	3	7	1050	730	1960	0	98146	47.5123	-122.337	1780	8113	0
9	3	2.50	1890	6560	2.0	3	7	1890	0	2003	0	98038	47.3684	-122.031	2390	7570	0

	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15	price_gt_1M
21603	3	2.50	2270	5536	2.0	3	8	2270	0	2003	98065	47.5389	-121.881	2270	5731	0
21604	3	2.00	1490	1126	3.0	3	8	1490	0	2014	98144	47.5699	-122.288	1400	1230	0
21605	4	2.50	2520	6023	2.0	3	9	2520	0	2014	98056	47.5137	-122.167	2520	6023	0
21606	4	3.50	3510	7200	2.0	3	9	2600	910	2009	98136	47.5537	-122.398	2050	6200	1
21607	3	2.50	1310	1294	2.0	3	8	1180	130	2008	98116	47.5773	-122.409	1330	1265	0
21608	3	2.50	1530	1131	3.0	3	8	1530	0	2009	98103	47.6993	-122.346	1530	1509	0
21609	4	2.50	2310	5813	2.0	3	8	2310	0	2014	98146	47.5107	-122.362	1830	7200	0
21610	2	0.75	1020	1350	2.0	3	7	1020	0	2009	98144	47.5944	-122.299	1020	2007	0
21611	3	2.50	1600	2388	2.0	3	8	1600	0	2004	98027	47.5345	-122.069	1410	1287	0
21612	2	0.75	1020	1076	2.0	3	7	1020	0	2008	98144	47.5941	-122.299	1020	1357	0

Most frequently occurring

	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	yr_built	zipcode	lat	long	sqft_living15	sqft_lot15	# duplicates
44	3	1.00	1080	6250	1.0	2	5	1080	1950	98168	47.5045	-122.330	1070	6250	3
0	1	0.75	840	7203	1.5	3	6	840	1949	98168	47.4756	-122.301	1560	8603	2
1	1	1.00	620	8261	1.0	3	5	620	1939	98106	47.5138	-122.364	1180	8244	2
2	1	1.00	850	8050	1.0	2	6	850	1906	98118	47.5427	-122.288	1590	5180	2
3	1	1.00	900	6380	1.0	3	6	900	1947	98125	47.7019	-122.311	1830	6380	2
4	1	2.00	1150	9812	1.0	4	7	1150	1962	98001	47.2951	-122.284	1200	9812	2
5	2	1.00	580	7500	1.0	3	5	580	1943	98178	47.4852	-122.251	1700	11250	2
6	2	1.00	700	4800	1.0	3	7	700	1922	98122	47.6147	-122.300	1440	4800	2
7	2	1.00	790	7153	1.0	4	6	790	1944	98168	47.4869	-122.324	810	7128	2
8	2	1.00	790	11234	1.0	4	6	790	1942	98166	47.4413	-122.349	1930	11871	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring